package org.bbs.demo.topic.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.bbs.demo.topic.model.TopicList;

import java.util.ArrayList;

@Mapper
public interface ShowTopSexy {

    @Select("select topic_id from bbstopic where date_sub(CURDATE(),INTERVAL 7 DAY) <= DATE(t_time) ORDER BY sexy DESC LIMIT #{num}")
    public ArrayList<String> showTopSexy(int num);
}
